From 61b355857376c822867711f09d5b02cdb65686a5 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 4 Aug 2026 00:02:53 +0000 Subject: [PATCH] Change so adolesent swelling is properly included in SWELLING_STATES --- conversion/load_support.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/conversion/load_support.sql b/conversion/load_support.sql index 4ccd1c1..ab9fd7e 100644 --- a/conversion/load_support.sql +++ b/conversion/load_support.sql @@ -89,12 +89,12 @@ insert into comm_ids (commid, name, notes, membcriteria) -- cycle_states INSERT INTO cycle_states (code, asnum, ssrank, description) - VALUES ('0', 0, 2, 'Not swollen') - , ('0.25', 0.25, 3, '1/4 swollen') - , ('0.5', 0.5, 4, '1/2 swollen') - , ('0.75', 0.75, 5, '3/4 swollen') - , ('1', 1.0, 6, 'Fully swollen') - , ('U', NULL, 1, 'Adolescent swelling') + VALUES ('0', 0, 1, 'Not swollen') + , ('0.25', 0.25, 2, '1/4 swollen') + , ('0.5', 0.5, 3, '1/2 swollen') + , ('0.75', 0.75, 4, '3/4 swollen') + , ('1', 1.0, 5, 'Fully swollen') + , ('U', NULL, 6, 'Adolescent swelling') , ('n/a', NULL, NULL, 'Male') , ('MISS', NULL, NULL, 'Missing data'); -- problem #42 -- 2.34.1